[dbo].[OrderCategoryParentLookup]

Property	Value
Row Count	3
Created	10:31:30 AM Tuesday, March 02, 2010
Last Modified	11:40:05 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:30 AM Tuesday, March 02, 2010

Last Modified

11:40:05 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key PK_OrderCategoryParentLookup: OrderCategoryID\OrderCategoryParentID$	OrderCategoryID	int	4
$Cluster Primary Key PK_OrderCategoryParentLookup: OrderCategoryID\OrderCategoryParentID$	OrderCategoryParentID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_OrderCategoryParentLookup: OrderCategoryID\OrderCategoryParentID$

OrderCategoryID

int

$Cluster Primary Key PK_OrderCategoryParentLookup: OrderCategoryID\OrderCategoryParentID$

OrderCategoryParentID

int

	Name	Columns	Unique
$Cluster Primary Key PK_OrderCategoryParentLookup: OrderCategoryID\OrderCategoryParentID$	PK_OrderCategoryParentLookup	OrderCategoryID, OrderCategoryParentID

Name

Columns

Unique

$Cluster Primary Key PK_OrderCategoryParentLookup: OrderCategoryID\OrderCategoryParentID$

PK_OrderCategoryParentLookup

OrderCategoryID, OrderCategoryParentID

Name	Update	Delete	Columns
FK_OrderCategoryParentLookup_OrderCategory	Cascade	Cascade	OrderCategoryParentID->[dbo].[OrderCategory].[OrderCategoryID]

Name

Update

Delete

Columns

FK_OrderCategoryParentLookup_OrderCategory

Cascade

OrderCategoryParentID->[dbo].[OrderCategory].[OrderCategoryID]

SQL Script

CREATE TABLE [dbo].[OrderCategoryParentLookup]
(
[OrderCategoryID] [int] NOT NULL,
[OrderCategoryParentID] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OrderCategoryParentLookup] ADD CONSTRAINT [PK_OrderCategoryParentLookup] PRIMARY KEY CLUSTERED ([OrderCategoryID], [OrderCategoryParentID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OrderCategoryParentLookup] ADD CONSTRAINT [FK_OrderCategoryParentLookup_OrderCategory] FOREIGN KEY ([OrderCategoryParentID]) REFERENCES [dbo].[OrderCategory] ([OrderCategoryID]) ON DELETE CASCADE ON UPDATE CASCADE
GO